<meta charset="UTF-8">
<?php
require_once '/config/config.php';

class DB {

    public $connection;

    public function connect() {

        $this->connection = mysql_connect(DB_HOST . ":" . DB_PORT, DB_USER, DB_PASS) or die(mysql_error());
        mysql_select_db(DB_NAME, $this->connection);
        return $this->connection;
    }

    public function query($query) {
        mysql_query('SET NAMES utf8', $this->connection);
        $data = mysql_query($query, $this->connection);
        $rows = array();
        while ($row = mysql_fetch_assoc($data)) {
            $rows[] = $row;
        }
        return $rows;
    }
     public function select() {
            $this->connect();
            $query = "SELECT * FROM keywords WHERE LENGTH(name) > 10";
            $keywords = $this->query($query);
            return $keywords;
        }

        public function select1() {
            $this->connect();
            $query = "SELECT * FROM works LIMIT 0,10 ";
            $works = $this->query($query);
            return $works;
        }

    }

    



